USE [[databasename]]
GO

SET NOCOUNT ON
GO

DELETE FROM [MessageType] WHERE [messageTypeID] in (1014, 1008, 1006, 1007, 1009, 1010, 1012, 1013, 1016, 1017, 1018, 1019, 1020, 1021, 1022, 1023, 1026, 1027, 1015, 1024, 1025, 1028, 1029, 1030, 1011, 1031, 1032, 1033, 1034, 1035, 1036, 1037, 1038, 1039, 1040, 1041, 1042, 1043, 1044, 1045, 1046, 1047, 1054, 1055, 1064, 1065, 1063, 1048, 1049, 1050, 1051, 1052, 1053, 1058, 1059, 1060, 1056, 1057, 1066, 1067, 1061, 1062, 1068, 1201, 1200, 9000, 2000, 2001, 1069, 9001, 1070, 1071, 9003, 9004)
GO

DELETE FROM [ServiceProviderTypeMessageType] WHERE [sourceServiceProviderTypeID] = 102 OR [destinationServiceProviderTypeID] = 102
GO

DELETE FROM [ServiceProviderPool] WHERE [serviceProviderID] = '102'
GO

DELETE FROM [ServiceProvider] WHERE [serviceProviderID] = '102'
GO

DELETE FROM [PoolServiceProviderType] WHERE [serviceProviderTypeID] = 102 AND [poolID] = 1
GO

DELETE FROM [ServiceProviderType] WHERE [serviceProviderTypeID] = 102
GO

DELETE FROM [aspnet_SchemaVersions] WHERE [feature] IN ('membership','role manager')
GO

DELETE FROM [aspnet_UsersInRoles] WHERE [userID] IN ('64fa71f5-d257-4efb-963b-cc956f3defcd')
GO

DELETE FROM [aspnet_Membership] WHERE [userID] IN ('64fa71f5-d257-4efb-963b-cc956f3defcd') AND [applicationID] IN ('936be925-be69-46ee-a072-0d028df0a981')
GO

DELETE FROM [aspnet_Users] WHERE [userID] IN ('64fa71f5-d257-4efb-963b-cc956f3defcd')
GO

DELETE FROM [aspnet_Applications] WHERE [applicationID] = '936be925-be69-46ee-a072-0d028df0a981'
GO

SET NOCOUNT OFF
GO

SET NOCOUNT ON
GO
 
SET IDENTITY_INSERT [dbo].[ServiceProviderType] ON
GO
 
PRINT 'Inserting values into [ServiceProviderType]'
INSERT INTO [ServiceProviderType] ([serviceProviderTypeID],[displayName],[serviceProviderTypeCode],[lockedUserID],[lockedDate],[status])VALUES(102,'Service Provider Register Admin Services','SPRAdmin',NULL,NULL,0)
PRINT 'Done'

SET IDENTITY_INSERT [dbo].[ServiceProviderType] OFF
GO

SET NOCOUNT OFF

GO

SET NOCOUNT ON

PRINT 'Inserting values into [PoolServiceProviderType]'
GO

INSERT INTO [PoolServiceProviderType] ([serviceProviderTypeID],[poolID])VALUES(102,1)
GO

SET NOCOUNT OFF
GO

SET NOCOUNT ON

PRINT 'Inserting values into [ServiceProvider]'
INSERT INTO [ServiceProvider] ([serviceProviderID],[displayName],[serviceProviderTypeID],[systemName],[publicKey],[webServiceURL],[interactiveSessionURI],[interactiveSessionTypeID],[adminContactName],[adminContactAddress1],[adminContactAddress2],[adminContactCity],[adminContactProvince],[adminContactPostalCode],[adminContactCountry],[adminContactPhone],[adminContactFax],[adminContactEmail],[encryptionType],[LockedUserID],[LockedDate],[status])VALUES('102','Service Provider Register Administration',102,'Service Provider Register Admin','[sprapublickey]','http://[sprhost]/[sprawssite]/ConnectionEngineAdapter.asmx',NULL,NULL,'Me','Unit X','333 Some St','Auckland','North Island','1000','NZ','+64 9 526 4005','','wagner.silveira@simpl.co.nz','TripleDES',NULL,NULL,0)
PRINT 'Done'
 
SET NOCOUNT OFF
GO

SET NOCOUNT ON
 
 
PRINT 'Inserting values into [ServiceProviderPool]'
INSERT INTO [ServiceProviderPool] ([serviceProviderID],[poolID])VALUES('102',1)
PRINT 'Done'
 
 
SET NOCOUNT OFF

GO

SET NOCOUNT ON
GO

SET IDENTITY_INSERT [dbo].[MessageType] ON
GO 
 
PRINT 'Inserting values into [MessageType]'
INSERT INTO [MessageType] ([messageTypeID],[description],[xmlSchema],[version],[lockedUserID],[lockedDate],[status])VALUES(1014,'Service Provider Search Request','http://[sprhost]/[sprwssite]/Schemas/ServiceProviderRegister/Admin/ServiceProviderSearchRequest.xsd','1.0',NULL,NULL,0)
INSERT INTO [MessageType] ([messageTypeID],[description],[xmlSchema],[version],[lockedUserID],[lockedDate],[status])VALUES(1008,'Service Provider Lock','http://[sprhost]/[sprwssite]/Schemas/ServiceProviderRegister/Admin/serviceprovideridrequest.xsd','1.0',NULL,NULL,0)
INSERT INTO [MessageType] ([messageTypeID],[description],[xmlSchema],[version],[lockedUserID],[lockedDate],[status])VALUES(1006,'Service Provider Delete','http://[sprhost]/[sprwssite]/Schemas/ServiceProviderRegister/Admin/serviceprovideridrequest.xsd','1.0',NULL,NULL,0)
INSERT INTO [MessageType] ([messageTypeID],[description],[xmlSchema],[version],[lockedUserID],[lockedDate],[status])VALUES(1007,'Service Provider UnLock','http://[sprhost]/[sprwssite]/Schemas/ServiceProviderRegister/Admin/serviceprovideridrequest.xsd','1.0',NULL,NULL,0)
INSERT INTO [MessageType] ([messageTypeID],[description],[xmlSchema],[version],[lockedUserID],[lockedDate],[status])VALUES(1009,'Service Provider Update','http://[sprhost]/[sprwssite]/Schemas/ServiceProviderRegister/Admin/serviceprovidereditrequest.xsd','1.0',NULL,NULL,0)
INSERT INTO [MessageType] ([messageTypeID],[description],[xmlSchema],[version],[lockedUserID],[lockedDate],[status])VALUES(1010,'Service Provider Insert','http://[sprhost]/[sprwssite]/Schemas/ServiceProviderRegister/Admin/serviceprovidereditrequest.xsd','1.0',NULL,NULL,0)
INSERT INTO [MessageType] ([messageTypeID],[description],[xmlSchema],[version],[lockedUserID],[lockedDate],[status])VALUES(1012,'Service Provider Update Result','http://[sprhost]/[sprwssite]/Schemas/ServiceProviderRegister/Admin/serviceprovider.xsd','1.0',NULL,NULL,0)
INSERT INTO [MessageType] ([messageTypeID],[description],[xmlSchema],[version],[lockedUserID],[lockedDate],[status])VALUES(1013,'Service Provider Check- Out Response','http://[sprhost]/[sprwssite]/Schemas/ServiceProviderRegister/Admin/serviceprovider.xsd','1.0',NULL,NULL,0)
INSERT INTO [MessageType] ([messageTypeID],[description],[xmlSchema],[version],[lockedUserID],[lockedDate],[status])VALUES(1016,'Pool Delete','http://[sprhost]/[sprwssite]/Schemas/ServiceProviderRegister/Admin/poolidrequest.xsd','1.0',NULL,NULL,0)
INSERT INTO [MessageType] ([messageTypeID],[description],[xmlSchema],[version],[lockedUserID],[lockedDate],[status])VALUES(1017,'Pool Check-In','http://[sprhost]/[sprwssite]/Schemas/ServiceProviderRegister/Admin/poolidrequest.xsd','1.0',NULL,NULL,0)
INSERT INTO [MessageType] ([messageTypeID],[description],[xmlSchema],[version],[lockedUserID],[lockedDate],[status])VALUES(1018,'Pool Check-Out','http://[sprhost]/[sprwssite]/Schemas/ServiceProviderRegister/Admin/poolidrequest.xsd','1.0',NULL,NULL,0)
INSERT INTO [MessageType] ([messageTypeID],[description],[xmlSchema],[version],[lockedUserID],[lockedDate],[status])VALUES(1019,'Pool Update','http://[sprhost]/[sprwssite]/Schemas/ServiceProviderRegister/Admin/pooleditrequest.xsd','1.0',NULL,NULL,0)
INSERT INTO [MessageType] ([messageTypeID],[description],[xmlSchema],[version],[lockedUserID],[lockedDate],[status])VALUES(1020,'Pool Insert','http://[sprhost]/[sprwssite]/Schemas/ServiceProviderRegister/Admin/pooleditrequest.xsd','1.0',NULL,NULL,0)
INSERT INTO [MessageType] ([messageTypeID],[description],[xmlSchema],[version],[lockedUserID],[lockedDate],[status])VALUES(1021,'Pool Insert Response','http://[sprhost]/[sprwssite]/Schemas/ServiceProviderRegister/Admin/pool.xsd','1.0',NULL,NULL,0)
INSERT INTO [MessageType] ([messageTypeID],[description],[xmlSchema],[version],[lockedUserID],[lockedDate],[status])VALUES(1022,'Pool Update Response','http://[sprhost]/[sprwssite]/Schemas/ServiceProviderRegister/Admin/pool.xsd','1.0',NULL,NULL,0)
INSERT INTO [MessageType] ([messageTypeID],[description],[xmlSchema],[version],[lockedUserID],[lockedDate],[status])VALUES(1023,'Pool Check-Out Response','http://[sprhost]/[sprwssite]/Schemas/ServiceProviderRegister/Admin/pool.xsd','1.0',NULL,NULL,0)
INSERT INTO [MessageType] ([messageTypeID],[description],[xmlSchema],[version],[lockedUserID],[lockedDate],[status])VALUES(1026,'Remove ServiceProvider From Pool','http://[sprhost]/[sprwssite]/Schemas/ServiceProviderRegister/Admin/ServiceProviderPoolInsertDelete.xsd','1.0',NULL,NULL,0)
INSERT INTO [MessageType] ([messageTypeID],[description],[xmlSchema],[version],[lockedUserID],[lockedDate],[status])VALUES(1027,'Add ServiceProvider To Pool','http://[sprhost]/[sprwssite]/Schemas/ServiceProviderRegister/Admin/ServiceProviderPoolInsertDelete.xsd','1.0',NULL,NULL,0)
INSERT INTO [MessageType] ([messageTypeID],[description],[xmlSchema],[version],[lockedUserID],[lockedDate],[status])VALUES(1015,'Service Provider Search Response','http://[sprhost]/[sprwssite]/Schemas/ServiceProviderRegister/Admin/ServiceProviders.xsd','1.0',NULL,NULL,0)
INSERT INTO [MessageType] ([messageTypeID],[description],[xmlSchema],[version],[lockedUserID],[lockedDate],[status])VALUES(1024,'Pool Search Request','http://[sprhost]/[sprwssite]/Schemas/ServiceProviderRegister/Admin/poolsearchrequest.xsd','1.0',NULL,NULL,0)
INSERT INTO [MessageType] ([messageTypeID],[description],[xmlSchema],[version],[lockedUserID],[lockedDate],[status])VALUES(1025,'Pool Search Response','http://[sprhost]/[sprwssite]/Schemas/ServiceProviderRegister/Admin/pools.xsd','1.0',NULL,NULL,0)
INSERT INTO [MessageType] ([messageTypeID],[description],[xmlSchema],[version],[lockedUserID],[lockedDate],[status])VALUES(1028,'Remover ServiceProviderType From Pool','http://[sprhost]/[sprwssite]/Schemas/ServiceProviderRegister/Admin/poolserviceprovidertypeeditrequest.xsd','1.0',NULL,NULL,0)
INSERT INTO [MessageType] ([messageTypeID],[description],[xmlSchema],[version],[lockedUserID],[lockedDate],[status])VALUES(1029,'Add ServiceProviderType To Pool','http://[sprhost]/[sprwssite]/Schemas/ServiceProviderRegister/Admin/poolserviceprovidertypeeditrequest.xsd','1.0',NULL,NULL,0)
INSERT INTO [MessageType] ([messageTypeID],[description],[xmlSchema],[version],[lockedUserID],[lockedDate],[status])VALUES(1030,'ServiceProviderType Delete','http://[sprhost]/[sprwssite]/Schemas/ServiceProviderRegister/Admin/serviceprovidertypeidrequest.xsd','1.0',NULL,NULL,0)
INSERT INTO [MessageType] ([messageTypeID],[description],[xmlSchema],[version],[lockedUserID],[lockedDate],[status])VALUES(1011,'Service Provider Insert Response','http://[sprhost]/[sprwssite]/Schemas/ServiceProviderRegister/Admin/serviceprovider.xsd','1.0',NULL,NULL,0)
INSERT INTO [MessageType] ([messageTypeID],[description],[xmlSchema],[version],[lockedUserID],[lockedDate],[status])VALUES(1031,'ServiceProviderType Check-In','http://[sprhost]/[sprwssite]/Schemas/ServiceProviderRegister/Admin/serviceprovidertypeidrequest.xsd','1.0',NULL,NULL,0)
INSERT INTO [MessageType] ([messageTypeID],[description],[xmlSchema],[version],[lockedUserID],[lockedDate],[status])VALUES(1032,'ServiceProviderType Check-Out','http://[sprhost]/[sprwssite]/Schemas/ServiceProviderRegister/Admin/serviceprovidertypeidrequest.xsd','1.0',NULL,NULL,0)
INSERT INTO [MessageType] ([messageTypeID],[description],[xmlSchema],[version],[lockedUserID],[lockedDate],[status])VALUES(1033,'ServiceProviderType Update','http://[sprhost]/[sprwssite]/Schemas/ServiceProviderRegister/Admin/serviceprovidertypeeditrequest.xsd','1.0',NULL,NULL,0)
INSERT INTO [MessageType] ([messageTypeID],[description],[xmlSchema],[version],[lockedUserID],[lockedDate],[status])VALUES(1034,'ServiceProviderType Insert','http://[sprhost]/[sprwssite]/Schemas/ServiceProviderRegister/Admin/serviceprovidertypeeditrequest.xsd','1.0',NULL,NULL,0)
INSERT INTO [MessageType] ([messageTypeID],[description],[xmlSchema],[version],[lockedUserID],[lockedDate],[status])VALUES(1035,'ServiceProviderType Insert Response','http://[sprhost]/[sprwssite]/Schemas/ServiceProviderRegister/Admin/serviceprovidertype.xsd','1.0',NULL,NULL,0)
INSERT INTO [MessageType] ([messageTypeID],[description],[xmlSchema],[version],[lockedUserID],[lockedDate],[status])VALUES(1036,'ServiceProviderType Update Response','http://[sprhost]/[sprwssite]/Schemas/ServiceProviderRegister/Admin/serviceprovidertype.xsd','1.0',NULL,NULL,0)
INSERT INTO [MessageType] ([messageTypeID],[description],[xmlSchema],[version],[lockedUserID],[lockedDate],[status])VALUES(1037,'ServiceProviderType Check-Out Response','http://[sprhost]/[sprwssite]/Schemas/ServiceProviderRegister/Admin/serviceprovidertype.xsd','1.0',NULL,NULL,0)
INSERT INTO [MessageType] ([messageTypeID],[description],[xmlSchema],[version],[lockedUserID],[lockedDate],[status])VALUES(1038,'Pool Check-In All','http://[sprhost]/[sprwssite]/Schemas/ServiceProviderRegister/Admin/poolunlockall.xsd','1.0',NULL,NULL,0)
INSERT INTO [MessageType] ([messageTypeID],[description],[xmlSchema],[version],[lockedUserID],[lockedDate],[status])VALUES(1039,'ServiceProviderType Check-In All','http://[sprhost]/[sprwssite]/Schemas/ServiceProviderRegister/Admin/serviceprovidertypeunlockall.xsd','1.0',NULL,NULL,0)
INSERT INTO [MessageType] ([messageTypeID],[description],[xmlSchema],[version],[lockedUserID],[lockedDate],[status])VALUES(1040,'ServiceProvider Unlock All','http://[sprhost]/[sprwssite]/Schemas/ServiceProviderRegister/Admin/serviceproviderunlockall.xsd','1.0',NULL,NULL,0)
INSERT INTO [MessageType] ([messageTypeID],[description],[xmlSchema],[version],[lockedUserID],[lockedDate],[status])VALUES(1041,'ServiceProviderType Search Request','http://[sprhost]/[sprwssite]/Schemas/ServiceProviderRegister/Admin/serviceprovidertypesearchrequest.xsd','1.0',NULL,NULL,0)
INSERT INTO [MessageType] ([messageTypeID],[description],[xmlSchema],[version],[lockedUserID],[lockedDate],[status])VALUES(1042,'ServiceProviderType Search Response','http://[sprhost]/[sprwssite]/Schemas/ServiceProviderRegister/Admin/serviceprovidertypes.xsd','1.0',NULL,NULL,0)
INSERT INTO [MessageType] ([messageTypeID],[description],[xmlSchema],[version],[lockedUserID],[lockedDate],[status])VALUES(1043,'MessageType Search Request','http://[sprhost]/[sprwssite]/Schemas/ServiceProviderRegister/Admin/messagetypesearchrequest.xsd','1.0',NULL,NULL,0)
INSERT INTO [MessageType] ([messageTypeID],[description],[xmlSchema],[version],[lockedUserID],[lockedDate],[status])VALUES(1044,'MessageType Search Response','http://[sprhost]/[sprwssite]/Schemas/ServiceProviderRegister/Admin/messagetypelist.xsd','1.0',NULL,NULL,0)
INSERT INTO [MessageType] ([messageTypeID],[description],[xmlSchema],[version],[lockedUserID],[lockedDate],[status])VALUES(1045,'MessageType Check-In','http://[sprhost]/[sprwssite]/Schemas/ServiceProviderRegister/Admin/messagetypeidrequest.xsd','1.0',NULL,NULL,0)
INSERT INTO [MessageType] ([messageTypeID],[description],[xmlSchema],[version],[lockedUserID],[lockedDate],[status])VALUES(1046,'MessageType Check-Out','http://[sprhost]/[sprwssite]/Schemas/ServiceProviderRegister/Admin/messagetypeidrequest.xsd','1.0',NULL,NULL,0)
INSERT INTO [MessageType] ([messageTypeID],[description],[xmlSchema],[version],[lockedUserID],[lockedDate],[status])VALUES(1047,'MessageType Check-Out Response','http://[sprhost]/[sprwssite]/Schemas/ServiceProviderRegister/Admin/messagetype.xsd','1.0',NULL,NULL,0)
INSERT INTO [MessageType] ([messageTypeID],[description],[xmlSchema],[version],[lockedUserID],[lockedDate],[status])VALUES(1054,'Add Service Provider Types to MessageType','http://[sprhost]/[sprwssite]/Schemas/ServiceProviderRegister/Admin/ServiceProviderTypeMessageTypeLinkEditRequest.xsd','1.0',NULL,NULL,0)
INSERT INTO [MessageType] ([messageTypeID],[description],[xmlSchema],[version],[lockedUserID],[lockedDate],[status])VALUES(1055,'Remove Service Provider Types from Message Type','http://[sprhost]/[sprwssite]/Schemas/ServiceProviderRegister/Admin/ServiceProviderTypeMessageTypeIDRequest.xsd','1.0',NULL,NULL,0)
INSERT INTO [MessageType] ([messageTypeID],[description],[xmlSchema],[version],[lockedUserID],[lockedDate],[status])VALUES(1064,'ServiceProviderType SelectItem Request','http://[sprhost]/[sprwssite]/Schemas/ServiceProviderRegister/Admin/serviceprovidertypeidrequest.xsd','1.0',NULL,NULL,0)
INSERT INTO [MessageType] ([messageTypeID],[description],[xmlSchema],[version],[lockedUserID],[lockedDate],[status])VALUES(1065,'ServiceProviderType SelectItem Result','http://[sprhost]/[sprwssite]/Schemas/ServiceProviderRegister/Admin/serviceprovidertype.xsd','1.0',NULL,NULL,0)
INSERT INTO [MessageType] ([messageTypeID],[description],[xmlSchema],[version],[lockedUserID],[lockedDate],[status])VALUES(1063,'PoolServiceProviderTypes Insert List Request','http://[sprhost]/[sprwssite]/Schemas/ServiceProviderRegister/Admin/poolserviceprovidertypelinkListEdit.xsd','1.0',NULL,NULL,0)
INSERT INTO [MessageType] ([messageTypeID],[description],[xmlSchema],[version],[lockedUserID],[lockedDate],[status])VALUES(1048,'MessageType Check-In All','http://[sprhost]/[sprwssite]/Schemas/ServiceProviderRegister/Admin/messagetypeunlockall.xsd','1.0',NULL,NULL,0)
INSERT INTO [MessageType] ([messageTypeID],[description],[xmlSchema],[version],[lockedUserID],[lockedDate],[status])VALUES(1049,'MessageType Insert','http://[sprhost]/[sprwssite]/Schemas/ServiceProviderRegister/Admin/messagetypeeditrequest.xsd','1.0',NULL,NULL,0)
INSERT INTO [MessageType] ([messageTypeID],[description],[xmlSchema],[version],[lockedUserID],[lockedDate],[status])VALUES(1050,'MessageType Insert Result','http://[sprhost]/[sprwssite]/Schemas/ServiceProviderRegister/Admin/messagetype.xsd','1.0',NULL,NULL,0)
INSERT INTO [MessageType] ([messageTypeID],[description],[xmlSchema],[version],[lockedUserID],[lockedDate],[status])VALUES(1051,'MessageType Update','http://[sprhost]/[sprwssite]/Schemas/ServiceProviderRegister/Admin/messagetypeeditrequest.xsd','1.0',NULL,NULL,0)
INSERT INTO [MessageType] ([messageTypeID],[description],[xmlSchema],[version],[lockedUserID],[lockedDate],[status])VALUES(1052,'MessageType Update Result','http://[sprhost]/[sprwssite]/Schemas/ServiceProviderRegister/Admin/messagetype.xsd','1.0',NULL,NULL,0)
INSERT INTO [MessageType] ([messageTypeID],[description],[xmlSchema],[version],[lockedUserID],[lockedDate],[status])VALUES(1053,'MessageType Delete','http://[sprhost]/[sprwssite]/Schemas/ServiceProviderRegister/Admin/messagetypeidrequest.xsd','1.0',NULL,NULL,0)
INSERT INTO [MessageType] ([messageTypeID],[description],[xmlSchema],[version],[lockedUserID],[lockedDate],[status])VALUES(1058,'ServiceProviderType MessageType Insert List','http://[sprhost]/[sprwssite]/Schemas/ServiceProviderRegister/Admin/ServiceProviderTypeMessageTypeLinkListEdit.xsd','1.0',NULL,NULL,0)
INSERT INTO [MessageType] ([messageTypeID],[description],[xmlSchema],[version],[lockedUserID],[lockedDate],[status])VALUES(1059,'ServiceProviderTypeMessageType Search Request','http://[sprhost]/[sprwssite]/Schemas/ServiceProviderRegister/Admin/ServiceProviderTypeMessageTypeSearchRequest.xsd','1.0',NULL,NULL,0)
INSERT INTO [MessageType] ([messageTypeID],[description],[xmlSchema],[version],[lockedUserID],[lockedDate],[status])VALUES(1060,'ServiceProviderTypeMessageType Search Result','http://[sprhost]/[sprwssite]/Schemas/ServiceProviderRegister/Admin/ServiceProviderTypeMessageTypeList.xsd','1.0',NULL,NULL,0)
INSERT INTO [MessageType] ([messageTypeID],[description],[xmlSchema],[version],[lockedUserID],[lockedDate],[status])VALUES(1056,'MessageType SelectItem Request','http://[sprhost]/[sprwssite]/Schemas/ServiceProviderRegister/Admin/messagetypeidrequest.xsd','1.0',NULL,NULL,0)
INSERT INTO [MessageType] ([messageTypeID],[description],[xmlSchema],[version],[lockedUserID],[lockedDate],[status])VALUES(1057,'MessageType SelectItem Result','http://[sprhost]/[sprwssite]/Schemas/ServiceProviderRegister/Admin/messagetype.xsd','1.0',NULL,NULL,0)
INSERT INTO [MessageType] ([messageTypeID],[description],[xmlSchema],[version],[lockedUserID],[lockedDate],[status])VALUES(1066,'Pool SelectItem Request','http://[sprhost]/[sprwssite]/Schemas/ServiceProviderRegister/Admin/poolidrequest.xsd','1.0',NULL,NULL,0)
INSERT INTO [MessageType] ([messageTypeID],[description],[xmlSchema],[version],[lockedUserID],[lockedDate],[status])VALUES(1067,'Pool SelectItem Result','http://[sprhost]/[sprwssite]/Schemas/ServiceProviderRegister/Admin/pool.xsd','1.0',NULL,NULL,0)
INSERT INTO [MessageType] ([messageTypeID],[description],[xmlSchema],[version],[lockedUserID],[lockedDate],[status])VALUES(1061,'Pool ServiceProviderType Search Request','http://[sprhost]/[sprwssite]/Schemas/ServiceProviderRegister/Admin/poolServiceProviderTypeSearchRequest.xsd','1.0',NULL,NULL,0)
INSERT INTO [MessageType] ([messageTypeID],[description],[xmlSchema],[version],[lockedUserID],[lockedDate],[status])VALUES(1062,'Pool ServiceProviderType Search Result','http://[sprhost]/[sprwssite]/Schemas/ServiceProviderRegister/Admin/poolServiceProviderTypelist.xsd','1.0',NULL,NULL,0)
INSERT INTO [MessageType] ([messageTypeID],[description],[xmlSchema],[version],[lockedUserID],[lockedDate],[status])VALUES(1068,'Pool ServiceProviderType Delete List','http://[sprhost]/[sprwssite]/Schemas/ServiceProviderRegister/Admin/poolserviceprovidertypelinkListEdit.xsd','1.0',NULL,NULL,0)
INSERT INTO [MessageType] ([messageTypeID],[description],[xmlSchema],[version],[lockedUserID],[lockedDate],[status])VALUES(2000,'Validate User Request','http://[sprhost]/[sprwssite]/Schemas/ServiceProviderRegister/Admin/usercredentials.xsd','1.0',NULL,NULL,0)
INSERT INTO [MessageType] ([messageTypeID],[description],[xmlSchema],[version],[lockedUserID],[lockedDate],[status])VALUES(2001,'Validate User Response','http://[sprhost]/[sprwssite]/Schemas/ServiceProviderRegister/Admin/hsdprincipal.xsd','1.0',NULL,NULL,0)
INSERT INTO [MessageType] ([messageTypeID],[description],[xmlSchema],[version],[lockedUserID],[lockedDate],[status])VALUES(1069,'ServiceProviderType MessageType Delete List','http://[sprhost]/[sprwssite]/Schemas/ServiceProviderRegister/Admin/ServiceProviderTypeMessageTypeLinkListEdit.xsd','1.0',NULL,NULL,0)
INSERT INTO [MessageType] ([messageTypeID],[description],[xmlSchema],[version],[lockedUserID],[lockedDate],[status])VALUES(1070,'ServiceProvider Select Request','http://[sprhost]/[sprwssite]/Schemas/ServiceProviderRegister/Admin/serviceprovideridrequest.xsd','1.0',NULL,NULL,0)
INSERT INTO [MessageType] ([messageTypeID],[description],[xmlSchema],[version],[lockedUserID],[lockedDate],[status])VALUES(1071,'ServiceProvider Select Result','http://[sprhost]/[sprwssite]/Schemas/ServiceProviderRegister/Admin/serviceprovider.xsd','1.0',NULL,NULL,0)
INSERT INTO [MessageType] ([messageTypeID],[description],[xmlSchema],[version],[lockedUserID],[lockedDate],[status])VALUES(9003,'ServiceProviderPool Delete List Request','http://[sprhost]/[sprwssite]/Schemas/serviceproviderpoollinkListEdit.xsd','1.0',NULL,NULL,0)
INSERT INTO [MessageType] ([messageTypeID],[description],[xmlSchema],[version],[lockedUserID],[lockedDate],[status])VALUES(9004,'ServiceProviderPool Insert List Request','http://[sprhost]/[sprwssite]/Schemas/serviceproviderpoollinkListEdit.xsd','1.0',NULL,NULL,0)
PRINT 'Done'
 
 
SET IDENTITY_INSERT [dbo].[MessageType] OFF
GO
SET NOCOUNT OFF

GO

SET NOCOUNT ON
 
SET IDENTITY_INSERT [dbo].[ServiceProviderTypeMessageType] ON
GO
 
 
PRINT 'Inserting values into [ServiceProviderTypeMessageType]'
INSERT INTO [ServiceProviderTypeMessageType] ([serviceProviderTypeMessageTypeID],[messageTypeID],[sourceServiceProviderTypeID],[destinationServiceProviderTypeID])VALUES(70,1000,102,101)
INSERT INTO [ServiceProviderTypeMessageType] ([serviceProviderTypeMessageTypeID],[messageTypeID],[sourceServiceProviderTypeID],[destinationServiceProviderTypeID])VALUES(71,1001,101,102)
INSERT INTO [ServiceProviderTypeMessageType] ([serviceProviderTypeMessageTypeID],[messageTypeID],[sourceServiceProviderTypeID],[destinationServiceProviderTypeID])VALUES(72,1002,102,101)
INSERT INTO [ServiceProviderTypeMessageType] ([serviceProviderTypeMessageTypeID],[messageTypeID],[sourceServiceProviderTypeID],[destinationServiceProviderTypeID])VALUES(73,1003,101,102)
INSERT INTO [ServiceProviderTypeMessageType] ([serviceProviderTypeMessageTypeID],[messageTypeID],[sourceServiceProviderTypeID],[destinationServiceProviderTypeID])VALUES(74,1006,102,101)
INSERT INTO [ServiceProviderTypeMessageType] ([serviceProviderTypeMessageTypeID],[messageTypeID],[sourceServiceProviderTypeID],[destinationServiceProviderTypeID])VALUES(75,1007,102,101)
INSERT INTO [ServiceProviderTypeMessageType] ([serviceProviderTypeMessageTypeID],[messageTypeID],[sourceServiceProviderTypeID],[destinationServiceProviderTypeID])VALUES(73,1008,102,101)
INSERT INTO [ServiceProviderTypeMessageType] ([serviceProviderTypeMessageTypeID],[messageTypeID],[sourceServiceProviderTypeID],[destinationServiceProviderTypeID])VALUES(76,1009,102,101)
INSERT INTO [ServiceProviderTypeMessageType] ([serviceProviderTypeMessageTypeID],[messageTypeID],[sourceServiceProviderTypeID],[destinationServiceProviderTypeID])VALUES(77,1010,102,101)
INSERT INTO [ServiceProviderTypeMessageType] ([serviceProviderTypeMessageTypeID],[messageTypeID],[sourceServiceProviderTypeID],[destinationServiceProviderTypeID])VALUES(103,1011,102,101)
INSERT INTO [ServiceProviderTypeMessageType] ([serviceProviderTypeMessageTypeID],[messageTypeID],[sourceServiceProviderTypeID],[destinationServiceProviderTypeID])VALUES(78,1012,102,101)
INSERT INTO [ServiceProviderTypeMessageType] ([serviceProviderTypeMessageTypeID],[messageTypeID],[sourceServiceProviderTypeID],[destinationServiceProviderTypeID])VALUES(79,1013,102,101)
INSERT INTO [ServiceProviderTypeMessageType] ([serviceProviderTypeMessageTypeID],[messageTypeID],[sourceServiceProviderTypeID],[destinationServiceProviderTypeID])VALUES(72,1014,102,101)
INSERT INTO [ServiceProviderTypeMessageType] ([serviceProviderTypeMessageTypeID],[messageTypeID],[sourceServiceProviderTypeID],[destinationServiceProviderTypeID])VALUES(90,1015,102,101)
INSERT INTO [ServiceProviderTypeMessageType] ([serviceProviderTypeMessageTypeID],[messageTypeID],[sourceServiceProviderTypeID],[destinationServiceProviderTypeID])VALUES(80,1016,102,101)
INSERT INTO [ServiceProviderTypeMessageType] ([serviceProviderTypeMessageTypeID],[messageTypeID],[sourceServiceProviderTypeID],[destinationServiceProviderTypeID])VALUES(81,1017,102,101)
INSERT INTO [ServiceProviderTypeMessageType] ([serviceProviderTypeMessageTypeID],[messageTypeID],[sourceServiceProviderTypeID],[destinationServiceProviderTypeID])VALUES(82,1018,102,101)
INSERT INTO [ServiceProviderTypeMessageType] ([serviceProviderTypeMessageTypeID],[messageTypeID],[sourceServiceProviderTypeID],[destinationServiceProviderTypeID])VALUES(83,1019,102,101)
INSERT INTO [ServiceProviderTypeMessageType] ([serviceProviderTypeMessageTypeID],[messageTypeID],[sourceServiceProviderTypeID],[destinationServiceProviderTypeID])VALUES(84,1020,102,101)
INSERT INTO [ServiceProviderTypeMessageType] ([serviceProviderTypeMessageTypeID],[messageTypeID],[sourceServiceProviderTypeID],[destinationServiceProviderTypeID])VALUES(85,1021,102,101)
INSERT INTO [ServiceProviderTypeMessageType] ([serviceProviderTypeMessageTypeID],[messageTypeID],[sourceServiceProviderTypeID],[destinationServiceProviderTypeID])VALUES(86,1022,102,101)
INSERT INTO [ServiceProviderTypeMessageType] ([serviceProviderTypeMessageTypeID],[messageTypeID],[sourceServiceProviderTypeID],[destinationServiceProviderTypeID])VALUES(86,1022,102,101)
INSERT INTO [ServiceProviderTypeMessageType] ([serviceProviderTypeMessageTypeID],[messageTypeID],[sourceServiceProviderTypeID],[destinationServiceProviderTypeID])VALUES(87,1023,102,101)
INSERT INTO [ServiceProviderTypeMessageType] ([serviceProviderTypeMessageTypeID],[messageTypeID],[sourceServiceProviderTypeID],[destinationServiceProviderTypeID])VALUES(91,1024,102,101)
INSERT INTO [ServiceProviderTypeMessageType] ([serviceProviderTypeMessageTypeID],[messageTypeID],[sourceServiceProviderTypeID],[destinationServiceProviderTypeID])VALUES(92,1025,102,101)
INSERT INTO [ServiceProviderTypeMessageType] ([serviceProviderTypeMessageTypeID],[messageTypeID],[sourceServiceProviderTypeID],[destinationServiceProviderTypeID])VALUES(88,1026,102,101)
INSERT INTO [ServiceProviderTypeMessageType] ([serviceProviderTypeMessageTypeID],[messageTypeID],[sourceServiceProviderTypeID],[destinationServiceProviderTypeID])VALUES(89,1027,102,101)
INSERT INTO [ServiceProviderTypeMessageType] ([serviceProviderTypeMessageTypeID],[messageTypeID],[sourceServiceProviderTypeID],[destinationServiceProviderTypeID])VALUES(93,1028,102,101)
INSERT INTO [ServiceProviderTypeMessageType] ([serviceProviderTypeMessageTypeID],[messageTypeID],[sourceServiceProviderTypeID],[destinationServiceProviderTypeID])VALUES(94,1029,102,101)
INSERT INTO [ServiceProviderTypeMessageType] ([serviceProviderTypeMessageTypeID],[messageTypeID],[sourceServiceProviderTypeID],[destinationServiceProviderTypeID])VALUES(95,1030,102,101)
INSERT INTO [ServiceProviderTypeMessageType] ([serviceProviderTypeMessageTypeID],[messageTypeID],[sourceServiceProviderTypeID],[destinationServiceProviderTypeID])VALUES(96,1031,102,101)
INSERT INTO [ServiceProviderTypeMessageType] ([serviceProviderTypeMessageTypeID],[messageTypeID],[sourceServiceProviderTypeID],[destinationServiceProviderTypeID])VALUES(97,1032,102,101)
INSERT INTO [ServiceProviderTypeMessageType] ([serviceProviderTypeMessageTypeID],[messageTypeID],[sourceServiceProviderTypeID],[destinationServiceProviderTypeID])VALUES(98,1033,102,101)
INSERT INTO [ServiceProviderTypeMessageType] ([serviceProviderTypeMessageTypeID],[messageTypeID],[sourceServiceProviderTypeID],[destinationServiceProviderTypeID])VALUES(99,1034,102,101)
INSERT INTO [ServiceProviderTypeMessageType] ([serviceProviderTypeMessageTypeID],[messageTypeID],[sourceServiceProviderTypeID],[destinationServiceProviderTypeID])VALUES(100,1035,102,101)
INSERT INTO [ServiceProviderTypeMessageType] ([serviceProviderTypeMessageTypeID],[messageTypeID],[sourceServiceProviderTypeID],[destinationServiceProviderTypeID])VALUES(101,1036,102,101)
INSERT INTO [ServiceProviderTypeMessageType] ([serviceProviderTypeMessageTypeID],[messageTypeID],[sourceServiceProviderTypeID],[destinationServiceProviderTypeID])VALUES(102,1037,102,101)
INSERT INTO [ServiceProviderTypeMessageType] ([serviceProviderTypeMessageTypeID],[messageTypeID],[sourceServiceProviderTypeID],[destinationServiceProviderTypeID])VALUES(104,1038,102,101)
INSERT INTO [ServiceProviderTypeMessageType] ([serviceProviderTypeMessageTypeID],[messageTypeID],[sourceServiceProviderTypeID],[destinationServiceProviderTypeID])VALUES(105,1039,102,101)
INSERT INTO [ServiceProviderTypeMessageType] ([serviceProviderTypeMessageTypeID],[messageTypeID],[sourceServiceProviderTypeID],[destinationServiceProviderTypeID])VALUES(106,1040,102,101)
INSERT INTO [ServiceProviderTypeMessageType] ([serviceProviderTypeMessageTypeID],[messageTypeID],[sourceServiceProviderTypeID],[destinationServiceProviderTypeID])VALUES(107,1041,102,101)
INSERT INTO [ServiceProviderTypeMessageType] ([serviceProviderTypeMessageTypeID],[messageTypeID],[sourceServiceProviderTypeID],[destinationServiceProviderTypeID])VALUES(108,1042,102,101)
INSERT INTO [ServiceProviderTypeMessageType] ([serviceProviderTypeMessageTypeID],[messageTypeID],[sourceServiceProviderTypeID],[destinationServiceProviderTypeID])VALUES(111,1043,102,101)
INSERT INTO [ServiceProviderTypeMessageType] ([serviceProviderTypeMessageTypeID],[messageTypeID],[sourceServiceProviderTypeID],[destinationServiceProviderTypeID])VALUES(113,1045,102,101)
INSERT INTO [ServiceProviderTypeMessageType] ([serviceProviderTypeMessageTypeID],[messageTypeID],[sourceServiceProviderTypeID],[destinationServiceProviderTypeID])VALUES(114,1046,102,101)
INSERT INTO [ServiceProviderTypeMessageType] ([serviceProviderTypeMessageTypeID],[messageTypeID],[sourceServiceProviderTypeID],[destinationServiceProviderTypeID])VALUES(116,1048,102,101)
INSERT INTO [ServiceProviderTypeMessageType] ([serviceProviderTypeMessageTypeID],[messageTypeID],[sourceServiceProviderTypeID],[destinationServiceProviderTypeID])VALUES(117,1049,102,101)
INSERT INTO [ServiceProviderTypeMessageType] ([serviceProviderTypeMessageTypeID],[messageTypeID],[sourceServiceProviderTypeID],[destinationServiceProviderTypeID])VALUES(119,1051,102,101)
INSERT INTO [ServiceProviderTypeMessageType] ([serviceProviderTypeMessageTypeID],[messageTypeID],[sourceServiceProviderTypeID],[destinationServiceProviderTypeID])VALUES(121,1053,102,101)
INSERT INTO [ServiceProviderTypeMessageType] ([serviceProviderTypeMessageTypeID],[messageTypeID],[sourceServiceProviderTypeID],[destinationServiceProviderTypeID])VALUES(123,1054,102,101)
INSERT INTO [ServiceProviderTypeMessageType] ([serviceProviderTypeMessageTypeID],[messageTypeID],[sourceServiceProviderTypeID],[destinationServiceProviderTypeID])VALUES(149,1055,102,101)
INSERT INTO [ServiceProviderTypeMessageType] ([serviceProviderTypeMessageTypeID],[messageTypeID],[sourceServiceProviderTypeID],[destinationServiceProviderTypeID])VALUES(130,1056,102,101)
INSERT INTO [ServiceProviderTypeMessageType] ([serviceProviderTypeMessageTypeID],[messageTypeID],[sourceServiceProviderTypeID],[destinationServiceProviderTypeID])VALUES(125,1058,102,101)
INSERT INTO [ServiceProviderTypeMessageType] ([serviceProviderTypeMessageTypeID],[messageTypeID],[sourceServiceProviderTypeID],[destinationServiceProviderTypeID])VALUES(128,1059,102,101)
INSERT INTO [ServiceProviderTypeMessageType] ([serviceProviderTypeMessageTypeID],[messageTypeID],[sourceServiceProviderTypeID],[destinationServiceProviderTypeID])VALUES(159,1061,102,101)
INSERT INTO [ServiceProviderTypeMessageType] ([serviceProviderTypeMessageTypeID],[messageTypeID],[sourceServiceProviderTypeID],[destinationServiceProviderTypeID])VALUES(134,1063,102,101)
INSERT INTO [ServiceProviderTypeMessageType] ([serviceProviderTypeMessageTypeID],[messageTypeID],[sourceServiceProviderTypeID],[destinationServiceProviderTypeID])VALUES(132,1064,102,101)
INSERT INTO [ServiceProviderTypeMessageType] ([serviceProviderTypeMessageTypeID],[messageTypeID],[sourceServiceProviderTypeID],[destinationServiceProviderTypeID])VALUES(135,1066,102,101)
INSERT INTO [ServiceProviderTypeMessageType] ([serviceProviderTypeMessageTypeID],[messageTypeID],[sourceServiceProviderTypeID],[destinationServiceProviderTypeID])VALUES(147,1068,102,101)
INSERT INTO [ServiceProviderTypeMessageType] ([serviceProviderTypeMessageTypeID],[messageTypeID],[sourceServiceProviderTypeID],[destinationServiceProviderTypeID])VALUES(196,1068,102,101)
INSERT INTO [ServiceProviderTypeMessageType] ([serviceProviderTypeMessageTypeID],[messageTypeID],[sourceServiceProviderTypeID],[destinationServiceProviderTypeID])VALUES(152,1069,102,101)
INSERT INTO [ServiceProviderTypeMessageType] ([serviceProviderTypeMessageTypeID],[messageTypeID],[sourceServiceProviderTypeID],[destinationServiceProviderTypeID])VALUES(162,1070,102,101)
INSERT INTO [ServiceProviderTypeMessageType] ([serviceProviderTypeMessageTypeID],[messageTypeID],[sourceServiceProviderTypeID],[destinationServiceProviderTypeID])VALUES(71,1200,102,101)
INSERT INTO [ServiceProviderTypeMessageType] ([serviceProviderTypeMessageTypeID],[messageTypeID],[sourceServiceProviderTypeID],[destinationServiceProviderTypeID])VALUES(222,1200,22,101)
INSERT INTO [ServiceProviderTypeMessageType] ([serviceProviderTypeMessageTypeID],[messageTypeID],[sourceServiceProviderTypeID],[destinationServiceProviderTypeID])VALUES(70,1201,102,101)
INSERT INTO [ServiceProviderTypeMessageType] ([serviceProviderTypeMessageTypeID],[messageTypeID],[sourceServiceProviderTypeID],[destinationServiceProviderTypeID])VALUES(109,2000,102,101)
INSERT INTO [ServiceProviderTypeMessageType] ([serviceProviderTypeMessageTypeID],[messageTypeID],[sourceServiceProviderTypeID],[destinationServiceProviderTypeID])VALUES(166,9000,102,101)
INSERT INTO [ServiceProviderTypeMessageType] ([serviceProviderTypeMessageTypeID],[messageTypeID],[sourceServiceProviderTypeID],[destinationServiceProviderTypeID])VALUES(164,9003,102,101)
INSERT INTO [ServiceProviderTypeMessageType] ([serviceProviderTypeMessageTypeID],[messageTypeID],[sourceServiceProviderTypeID],[destinationServiceProviderTypeID])VALUES(165,9004,102,101)
INSERT INTO [ServiceProviderTypeMessageType] ([serviceProviderTypeMessageTypeID],[messageTypeID],[sourceServiceProviderTypeID],[destinationServiceProviderTypeID])VALUES(112,1044,101,102)
INSERT INTO [ServiceProviderTypeMessageType] ([serviceProviderTypeMessageTypeID],[messageTypeID],[sourceServiceProviderTypeID],[destinationServiceProviderTypeID])VALUES(115,1047,101,102)
INSERT INTO [ServiceProviderTypeMessageType] ([serviceProviderTypeMessageTypeID],[messageTypeID],[sourceServiceProviderTypeID],[destinationServiceProviderTypeID])VALUES(118,1050,101,102)
INSERT INTO [ServiceProviderTypeMessageType] ([serviceProviderTypeMessageTypeID],[messageTypeID],[sourceServiceProviderTypeID],[destinationServiceProviderTypeID])VALUES(120,1052,101,102)
INSERT INTO [ServiceProviderTypeMessageType] ([serviceProviderTypeMessageTypeID],[messageTypeID],[sourceServiceProviderTypeID],[destinationServiceProviderTypeID])VALUES(131,1057,101,102)
INSERT INTO [ServiceProviderTypeMessageType] ([serviceProviderTypeMessageTypeID],[messageTypeID],[sourceServiceProviderTypeID],[destinationServiceProviderTypeID])VALUES(129,1060,101,102)
INSERT INTO [ServiceProviderTypeMessageType] ([serviceProviderTypeMessageTypeID],[messageTypeID],[sourceServiceProviderTypeID],[destinationServiceProviderTypeID])VALUES(160,1062,101,102)
INSERT INTO [ServiceProviderTypeMessageType] ([serviceProviderTypeMessageTypeID],[messageTypeID],[sourceServiceProviderTypeID],[destinationServiceProviderTypeID])VALUES(133,1065,101,102)
INSERT INTO [ServiceProviderTypeMessageType] ([serviceProviderTypeMessageTypeID],[messageTypeID],[sourceServiceProviderTypeID],[destinationServiceProviderTypeID])VALUES(136,1067,101,102)
INSERT INTO [ServiceProviderTypeMessageType] ([serviceProviderTypeMessageTypeID],[messageTypeID],[sourceServiceProviderTypeID],[destinationServiceProviderTypeID])VALUES(163,1071,101,102)
INSERT INTO [ServiceProviderTypeMessageType] ([serviceProviderTypeMessageTypeID],[messageTypeID],[sourceServiceProviderTypeID],[destinationServiceProviderTypeID])VALUES(110,2001,101,102)
--These are for some other registers
--INSERT INTO [ServiceProviderTypeMessageType] ([serviceProviderTypeMessageTypeID],[messageTypeID],[sourceServiceProviderTypeID],[destinationServiceProviderTypeID])VALUES(223,1201,101,22)
--INSERT INTO [ServiceProviderTypeMessageType] ([serviceProviderTypeMessageTypeID],[messageTypeID],[sourceServiceProviderTypeID],[destinationServiceProviderTypeID])VALUES(195,2001,101,12)

--INSERT INTO [ServiceProviderTypeMessageType] ([serviceProviderTypeMessageTypeID],[messageTypeID],[sourceServiceProviderTypeID],[destinationServiceProviderTypeID])VALUES(194,2000,12,5)
--INSERT INTO [ServiceProviderTypeMessageType] ([serviceProviderTypeMessageTypeID],[messageTypeID],[sourceServiceProviderTypeID],[destinationServiceProviderTypeID])VALUES(242,2000,24,5)
--INSERT INTO [ServiceProviderTypeMessageType] ([serviceProviderTypeMessageTypeID],[messageTypeID],[sourceServiceProviderTypeID],[destinationServiceProviderTypeID])VALUES(243,2000,25,5)
--INSERT INTO [ServiceProviderTypeMessageType] ([serviceProviderTypeMessageTypeID],[messageTypeID],[sourceServiceProviderTypeID],[destinationServiceProviderTypeID])VALUES(157,9001,10,11)
--INSERT INTO [ServiceProviderTypeMessageType] ([serviceProviderTypeMessageTypeID],[messageTypeID],[sourceServiceProviderTypeID],[destinationServiceProviderTypeID])VALUES(158,9001,11,10)
PRINT 'Done'
 
 
SET IDENTITY_INSERT [dbo].[ServiceProviderTypeMessageType] OFF
GO
SET NOCOUNT OFF

GO
SET NOCOUNT ON
 
 
PRINT 'Inserting values into [aspnet_Applications]'

INSERT INTO [aspnet_Applications] ([ApplicationName],[LoweredApplicationName],[ApplicationId],[Description])VALUES('HSD','hsd','936BE925-BE69-46EE-A072-0D028DF0A981',NULL)
PRINT 'Done'
 
 
SET NOCOUNT OFF
GO
 
SET NOCOUNT ON
 
 
PRINT 'Inserting values into [aspnet_Users]'

INSERT INTO [aspnet_Users] ([ApplicationId],[UserId],[UserName],[LoweredUserName],[MobileAlias],[IsAnonymous],[LastActivityDate],[HCUID],[ServiceProviderID])VALUES('936BE925-BE69-46EE-A072-0D028DF0A981','64FA71F5-D257-4EFB-963B-CC956F3DEFCD','me','me','',0,'Jan  1 1753 12:00:00:000AM','abc123','hsd')
PRINT 'Done'
 
 
SET NOCOUNT OFF

GO
 
SET NOCOUNT ON
 
 
PRINT 'Inserting values into [aspnet_Membership]'

INSERT INTO [aspnet_Membership] ([ApplicationId],[UserId],[Password],[PasswordFormat],[PasswordSalt],[MobilePIN],[Email],[LoweredEmail],[PasswordQuestion],[PasswordAnswer],[IsApproved],[IsLockedOut],[CreateDate],[LastLoginDate],[LastPasswordChangedDate],[LastLockoutDate],[FailedPasswordAttemptCount],[FailedPasswordAttemptWindowStart],[FailedPasswordAnswerAttemptCount],[FailedPasswordAnswerAttemptWindowStart],[Comment])VALUES('936BE925-BE69-46EE-A072-0D028DF0A981','64FA71F5-D257-4EFB-963B-CC956F3DEFCD','!password01',0,'','','me','me',NULL,NULL,1,0,'May  2 2006 12:06:23:383PM','Jan  1 1753 12:00:00:000AM','Jan  1 1753 12:00:00:000AM','Jan  1 1753 12:00:00:000AM',0,'Jan  1 1753 12:00:00:000AM',0,'Jan  1 1753 12:00:00:000AM',' ')
PRINT 'Done'
 
 
SET NOCOUNT OFF

GO

SET NOCOUNT ON
 
 
PRINT 'Inserting values into [aspnet_Roles]'

INSERT INTO [aspnet_Roles] ([ApplicationId],[RoleId],[RoleName],[LoweredRoleName],[Description])VALUES('936BE925-BE69-46EE-A072-0D028DF0A981','BEFE00B9-AF06-419A-A8BB-EF8D6BCA7896','Administrator','administrator','admin')
INSERT INTO [aspnet_Roles] ([ApplicationId],[RoleId],[RoleName],[LoweredRoleName],[Description])VALUES('936BE925-BE69-46EE-A072-0D028DF0A981','F616104A-3B4D-4A34-863A-338B0728BF6A','Client','client','client')
PRINT 'Done'
 
 
SET NOCOUNT OFF

GO

SET NOCOUNT ON
 
 
PRINT 'Inserting values into [aspnet_UsersInRoles]'

INSERT INTO [aspnet_UsersInRoles] ([UserId],[RoleId])VALUES('64FA71F5-D257-4EFB-963B-CC956F3DEFCD','F616104A-3B4D-4A34-863A-338B0728BF6A')
INSERT INTO [aspnet_UsersInRoles] ([UserId],[RoleId])VALUES('64FA71F5-D257-4EFB-963B-CC956F3DEFCD','BEFE00B9-AF06-419A-A8BB-EF8D6BCA7896')
PRINT 'Done'
 
 
SET NOCOUNT OFF

GO

SET NOCOUNT ON
 
PRINT 'Inserting values into [aspnet_SchemaVersions]'

INSERT INTO [aspnet_SchemaVersions] ([Feature],[CompatibleSchemaVersion],[IsCurrentVersion])VALUES('membership','1',1)
INSERT INTO [aspnet_SchemaVersions] ([Feature],[CompatibleSchemaVersion],[IsCurrentVersion])VALUES('role manager','1',1)
PRINT 'Done'
 
 
SET NOCOUNT OFF